﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="accdetail.aspx.vb" Inherits="OAR.accdetail" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="FeaturedContent" runat="server">
    <p>
        <br />
    </p>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="MainContent" runat="server">
    <p>
        <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" DataSourceID="ClaimsDataSource" Height="50px" Width="909px" AllowPaging="True">
            <EditRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
            <Fields>
                <asp:BoundField DataField="accidentNbr" HeaderText="Ref Nbr" InsertVisible="False" SortExpression="accidentNbr" />
                <asp:BoundField DataField="transactionDate" HeaderText="Date Captured" SortExpression="transactionDate" />
                <asp:BoundField DataField="reporterPosition" HeaderText="Captured By" SortExpression="reporterPosition" />
                <asp:BoundField DataField="employerName" HeaderText="Employer" SortExpression="employerName" />
                <asp:BoundField DataField="employerAddress" HeaderText="Employer Address" SortExpression="employerAddress" />
                <asp:BoundField DataField="employerBusinessCode" HeaderText="Business Sector" SortExpression="employerBusinessCode" />
                <asp:BoundField DataField="employerTelNbr" HeaderText="Employer's Tel Nbr" SortExpression="employerTelNbr" />
                <asp:BoundField DataField="employerEmail" HeaderText="Email" SortExpression="employerEmail" />
                <asp:BoundField DataField="workerName" HeaderText="Worker's Name" SortExpression="workerName" />
                <asp:BoundField DataField="workerGender" HeaderText="Gender" SortExpression="workerGender" />
                <asp:BoundField DataField="workerNrc" HeaderText="Nrc" SortExpression="workerNrc" />
                <asp:BoundField DataField="workerOccupation" HeaderText="Occupation" SortExpression="workerOccupation" />
                <asp:BoundField DataField="workerDOB" HeaderText="Date Of Birth" SortExpression="workerDOB" />
                <asp:BoundField DataField="workerVillage" HeaderText="Village" SortExpression="workerVillage" />
                <asp:BoundField DataField="workerChief" HeaderText="Chief" SortExpression="workerChief" />
                <asp:BoundField DataField="workerDistrict" HeaderText="District" SortExpression="workerDistrict" />
                <asp:BoundField DataField="workerAddress" HeaderText="Address" SortExpression="workerAddress" />
                <asp:BoundField DataField="workerEmail" HeaderText="Email" SortExpression="workerEmail" />
                <asp:BoundField DataField="workerTelNbr" HeaderText="Tel Nbr" SortExpression="workerTelNbr" />
                <asp:BoundField DataField="workerMaritalStatus" HeaderText="Marital Status" SortExpression="workerMaritalStatus" />
                <asp:BoundField DataField="workerSpouseName" HeaderText="Spouse Name" SortExpression="workerSpouseName" />
                <asp:BoundField DataField="workerSpouseDob" HeaderText="Spouse Date Of Birth" SortExpression="workerSpouseDob" />
                <asp:BoundField DataField="workerRLHanded" HeaderText="Worker R/L Handed" SortExpression="workerRLHanded" />
                <asp:BoundField DataField="Expr1" HeaderText="Expr1" SortExpression="Expr1" />
                <asp:BoundField DataField="lengthServiceYears" HeaderText="Length of Service (Years)" SortExpression="lengthServiceYears" />
                <asp:BoundField DataField="lengthServiceMonths" HeaderText="(or) Length Of Service (Months)" SortExpression="lengthServiceMonths" />
                <asp:BoundField DataField="lengthServiceWeeks" HeaderText="(or) Length of Service (Weeks)" SortExpression="lengthServiceWeeks" />
                <asp:BoundField DataField="subContractorName" HeaderText="If not direct employee, subContractor Name" SortExpression="subContractorName" />
                <asp:BoundField DataField="subContractorAddress" HeaderText="If not direct employee, subContractor Address" SortExpression="subContractorAddress" />
                <asp:BoundField DataField="priorDefect" HeaderText="Prior to this accident, had s/he any physical defect or serious disease?" SortExpression="priorDefect" />
                <asp:BoundField DataField="priorDefectDetails" HeaderText="If so, please give details of prior defects/diseases" SortExpression="priorDefectDetails" />
                <asp:BoundField DataField="basicWageHour" HeaderText="Basic Wages, excluding bonus, commission or allowances) Per Hour" SortExpression="basicWageHour" />
                <asp:BoundField DataField="basicWageShift" HeaderText="Basic Wages, excluding bonus, commission or allowances) Per Shift" SortExpression="basicWageShift" />
                <asp:BoundField DataField="basicWageWeek" HeaderText="Basic Wages, excluding bonus, commission or allowances) Per Week" SortExpression="basicWageWeek" />
                <asp:BoundField DataField="basicWageTicket" HeaderText="Basic Wages, excluding bonus, commission or allowances) Per Ticket" SortExpression="basicWageTicket" />
                <asp:BoundField DataField="basicWageMonth" HeaderText="Basic Wages, excluding bonus, commission or allowances) Per Month" SortExpression="basicWageMonth" />
                <asp:BoundField DataField="workingHoursWeek" HeaderText="Normal working hours per week" SortExpression="workingHoursWeek" />
                <asp:BoundField DataField="workingHoursShift" HeaderText="(or) normal working hours per shift" SortExpression="workingHoursShift" />
                <asp:BoundField DataField="previousCompensation" HeaderText="Has s/he previously received compensation for permanent disablement?" SortExpression="previousCompensation" />
                <asp:BoundField DataField="previousEmploymentDate" HeaderText="If yes, when was s/he employed?" SortExpression="previousEmploymentDate" />
                <asp:BoundField DataField="previousEmployer" HeaderText="If yes, by whom was s/he employed?" SortExpression="previousEmployer" />
                <asp:BoundField DataField="accidentSite" HeaderText="where did the accident occur?" SortExpression="accidentSite" />
                <asp:BoundField DataField="accidentDate" HeaderText="What date did the accident occur?" SortExpression="accidentDate" />
                <asp:BoundField DataField="accidentTime" HeaderText="What time did the accident occur?" SortExpression="accidentTime" />
                <asp:BoundField DataField="dateAccidentReported" HeaderText="What date did the worker report the accident?" SortExpression="dateAccidentReported" />
                <asp:BoundField DataField="timeAccidentReported" HeaderText="What time did the worker report the accident?" SortExpression="timeAccidentReported" />
                <asp:BoundField DataField="nonReportExplain" HeaderText="If not reported on the same day, what is the explanation?" SortExpression="nonReportExplain" />
                <asp:BoundField DataField="accidentDescription" HeaderText="Describe how the accident happened" SortExpression="accidentDescription" />
                <asp:BoundField DataField="accidentResult" HeaderText="Did accident result from action within scope of workers'duties?" SortExpression="accidentResult" />
                <asp:BoundField DataField="accidentResultStatement" HeaderText="If not, please provide explanatory statement" SortExpression="accidentResultStatement" />
                <asp:BoundField DataField="accidentViolation" HeaderText="Was accident caused by deliberate violation of rules/regulations?" SortExpression="accidentViolation" />
                <asp:BoundField DataField="accidentDrunk" HeaderText="Was accident caused by drunkennes?" SortExpression="accidentDrunk" />
                <asp:BoundField DataField="accidentContravention" HeaderText="Was accident caused by deliberate contravention of any law ensuring safety of workers?" SortExpression="accidentContravention" />
                <asp:BoundField DataField="accidentCauseStatement" HeaderText="If reply affirmative, please provide explanatory statement" SortExpression="accidentCauseStatement" />
                <asp:BoundField DataField="accidentWitness" HeaderText="Accident Witness Name" SortExpression="accidentWitness" />
                <asp:BoundField DataField="accidentWitnessAddress" HeaderText="Accident Witness Address" SortExpression="accidentWitnessAddress" />
                <asp:BoundField DataField="accidentWitnessTelNbr" HeaderText="Accident Witness Tel Nbr" SortExpression="accidentWitnessTelNbr" />
                <asp:BoundField DataField="accidentOtherAction" HeaderText="Was accident caused by the action of a person other than the worker?" SortExpression="accidentOtherAction" />
                <asp:BoundField DataField="accidentOtherActionName" HeaderText="If yes, give that person's name" SortExpression="accidentOtherActionName" />
                <asp:BoundField DataField="accidentOtherActionAddress" HeaderText="If yes, give that person's address" SortExpression="accidentOtherActionAddress" />
                <asp:BoundField DataField="accidentOtherActionEmail" HeaderText="If yes, give that person's email address" SortExpression="accidentOtherActionEmail" />
                <asp:BoundField DataField="accidentOtherActionTelNbr" HeaderText="If yes, give that person's Tel/Cell nbr" SortExpression="accidentOtherActionTelNbr" />
                <asp:BoundField DataField="officialNotice" HeaderText="Has notice been received of magisterial or other official enquiry?" SortExpression="officialNotice" />
                <asp:BoundField DataField="policeStationName" HeaderText="If accident investigated by police, state name of police station" SortExpression="policeStationName" />
                <asp:BoundField DataField="natureOfInjury" HeaderText="Describe nature and extent of injuries sustained" SortExpression="natureOfInjury" />
                <asp:BoundField DataField="ceaseWorkDate" HeaderText="What date did the worker cease work as a result of the accident ?" SortExpression="ceaseWorkDate" />
                <asp:BoundField DataField="ceaseWorkTime" HeaderText="What time did the worker cease work as a result of the accident ?" SortExpression="ceaseWorkTime" />
                <asp:BoundField DataField="monthsOffDuty" HeaderText="Probable period worker will be offduty, in months" SortExpression="monthsOffDuty" />
                <asp:BoundField DataField="weeksOffDuty" HeaderText="(or) Probable period worker will be offduty, in weeks" SortExpression="weeksOffDuty" />
                <asp:BoundField DataField="daysOffDuty" HeaderText="(or) Probable period worker will be offduty, in days" SortExpression="daysOffDuty" />
                <asp:BoundField DataField="doctorName" HeaderText="Name of doctor attending to worker" SortExpression="doctorName" />
                <asp:BoundField DataField="doctorAddress" HeaderText="Address of doctor attending to worker" SortExpression="doctorAddress" />
                <asp:BoundField DataField="hospitalName" HeaderText="If in hospital, name of hospital" SortExpression="hospitalName" />
                <asp:BoundField DataField="hospitalAddress" HeaderText="If in hospital, address of hospital" SortExpression="hospitalAddress" />
                <asp:BoundField DataField="Expr2" HeaderText="Expr2" InsertVisible="False" SortExpression="Expr2" />
                <asp:BoundField DataField="workerManNbr" HeaderText="workerManNbr" SortExpression="workerManNbr" />
                <asp:BoundField DataField="Expr3" HeaderText="Expr3" SortExpression="Expr3" />
            </Fields>
            <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
            <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
            <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
            <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
        </asp:DetailsView>
        <asp:SqlDataSource ID="ClaimsDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ClaimsConnectionString %>" ProviderName="<%$ ConnectionStrings:ClaimsConnectionString.ProviderName %>" SelectCommand="SELECT Employer.ID, Employer.employerNbr, Employer.employerName, Employer.employerAddress, Employer.employerBusinessCode, Employer.employerTelNbr, Employer.employerEmail, Employer.townCode, Form6.employerNbr AS Expr1, Form6.workerNrc, Form6.reporterPosition, Form6.accidentNbr, Form6.transactionDate, Form6.lengthServiceYears, Form6.lengthServiceMonths, Form6.lengthServiceWeeks, Form6.subContractorName, Form6.subContractorAddress, Form6.priorDefect, Form6.priorDefectDetails, Form6.basicWageHour, Form6.basicWageShift, Form6.basicWageWeek, Form6.basicWageTicket, Form6.basicWageMonth, Form6.workingHoursWeek, Form6.workingHoursShift, Form6.previousCompensation, Form6.previousEmploymentDate, Form6.previousEmployer, Form6.accidentSite, Form6.accidentDate, Form6.accidentTime, Form6.dateAccidentReported, Form6.timeAccidentReported, Form6.nonReportExplain, Form6.accidentDescription, Form6.accidentResult, Form6.accidentResultStatement, Form6.accidentViolation, Form6.accidentDrunk, Form6.accidentContravention, Form6.accidentCauseStatement, Form6.accidentWitness, Form6.accidentWitnessAddress, Form6.accidentWitnessTelNbr, Form6.accidentOtherAction, Form6.accidentOtherActionName, Form6.accidentOtherActionAddress, Form6.accidentOtherActionEmail, Form6.accidentOtherActionTelNbr, Form6.officialNotice, Form6.policeStationName, Form6.natureOfInjury, Form6.ceaseWorkDate, Form6.ceaseWorkTime, Form6.monthsOffDuty, Form6.weeksOffDuty, Form6.daysOffDuty, Form6.doctorName, Form6.doctorAddress, Form6.hospitalName, Form6.hospitalAddress, Worker.ID AS Expr2, Worker.workerManNbr, Worker.workerNrc AS Expr3, Worker.workerName, Worker.workerGender, Worker.workerOccupation, Worker.workerDOB, Worker.workerVillage, Worker.workerChief, Worker.workerDistrict, Worker.workerAddress, Worker.workerEmail, Worker.workerTelNbr, Worker.workerMaritalStatus, Worker.workerSpouseName, Worker.workerSpouseDob, Worker.workerRLHanded FROM ((Employer INNER JOIN Form6 ON Employer.employerNbr = Form6.employerNbr) INNER JOIN Worker ON Form6.workerNrc = Worker.workerNrc)
WHERE  (Form6.accidentNbr = ?)">
            <SelectParameters>
                <asp:QueryStringParameter Name="?" QueryStringField="accidentNbr" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
    </p>
</asp:Content>
